package io.renren.utils;

import io.renren.entity.ColumnEntity;
import io.renren.entity.TableEntity;
import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.WordUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.math.BigDecimal;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器   工具类
 *
 * @author chenshun
 * @email sunlightcs@gmail.com
 * @date 2016年12月19日 下午11:40:24
 */
public class GenUtils {

    public static List<String> getTemplates(){


        Configuration config = getConfig();

        List<String> templates = new ArrayList<>();
        if (config.getBoolean("enableJPA" , false)){
            templates.add("template/Entity.java.vm");
            templates.add("template/Repository.java.vm" );
        }
        //templates.add("template/Dao.java.vm");
        templates.add("template/Model.java.vm");
        if (config.getBoolean("enableMybatis" , false)){
            templates.add("template/Mapper.xml.vm" );
        }
        templates.add("template/VO.java.vm");
        templates.add("template/Service.java.vm");
        templates.add("template/ServiceImpl.java.vm");
        templates.add("template/BizCheck.java.vm");
        templates.add("template/Controller.java.vm");
        templates.add("template/index.html.vm");
        templates.add("template/edit.html.vm");
        templates.add("template/index-thymeleaf.html.vm");
        /*templates.add("template/menu.sql.vm");
        templates.add("template/index.html.vm");
        templates.add("template/edit.html.vm");*/
        //templates.add("template/index.vue.vm");
        //templates.add("template/add-or-update.vue.vm");

        return templates;
    }


    public static List<String> getTemplatesPlus(){


        List<String> templates = new ArrayList<>();

        templates.add("template/plus/Assembler.java.vm");
        templates.add("template/plus/Mapper.xml.vm");
        templates.add("template/plus/Mapper.java.vm");
        templates.add("template/plus/Entity.java.vm");
        templates.add("template/plus/Query.java.vm");
        templates.add("template/plus/VO.java.vm");
        templates.add("template/plus/CreateCmd.java.vm");
        templates.add("template/plus/UpdateCmd.java.vm");
        templates.add("template/plus/Service.java.vm");
        templates.add("template/plus/ServiceImpl.java.vm");
        templates.add("template/plus/BizCheck.java.vm");
        templates.add("template/plus/Controller.java.vm");
        templates.add("template/plus/test.http.vm");
        /*templates.add("template/index.html.vm");
        templates.add("template/edit.html.vm");
        templates.add("template/index-thymeleaf.html.vm");*/

        return templates;
    }

    /**
     * 生成代码
     */
    public static void generatorCode(Map<String, String> table,
                                     List<Map<String, String>> columns, ZipOutputStream zip) {
        //配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        boolean hasDate = false;
        //表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName" ));
        tableEntity.setComments(table.get("tableComment" ));
        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getStringArray("tablePrefix"));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));

        //列信息
        List<ColumnEntity> columnsList = new ArrayList<>();
        for(Map<String, String> column : columns){
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName(column.get("columnName").toLowerCase(Locale.ROOT));
            columnEntity.setDataType(column.get("dataType"));
            columnEntity.setComments(column.get("columnComment"));
            columnEntity.setExtra(column.get("extra" ));
            columnEntity.setDataLength(Integer.parseInt(column.get("dataLength")));
            String dataScale = column.get("dataScale");
            if (StringUtils.isNotBlank(dataScale)){
                columnEntity.setDataScale(Integer.parseInt(dataScale));
            }
            columnEntity.setNullable(column.get("nullable"));

            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

            //列的数据类型，转换成Java类型
            String attrType = config.getString(columnEntity.getDataType(), "unknowType" );
            columnEntity.setAttrType(attrType);


            if ("NUMBER".equals(columnEntity.getDataType())){
                Integer dataLength = columnEntity.getDataLength();
                columnEntity.setDataLength(dataLength);
                Integer dataScale1 = columnEntity.getDataScale();
                if (null != dataScale1 && 0 != dataScale1){
                    columnEntity.setAttrType("BigDecimal");
                    dataLength -= dataScale1;
                }
                else if (dataLength > 9 ){
                    columnEntity.setAttrType("Long");
                }
                if (dataLength<19){
                    StringBuilder sb = new StringBuilder(dataLength);
                    for (int i = 0; i < dataLength; i++) {
                        sb.append(9);
                    }
                    columnEntity.setMaxValue(Long.parseLong(sb.toString()));
                }else{
                    columnEntity.setMaxValue(Long.MAX_VALUE);
                }

                attrType = columnEntity.getAttrType();
            }

            if (!hasBigDecimal && "BigDecimal".equals(attrType)) {
                hasBigDecimal = true;
            }
            if (!hasDate && ("Date".equals(attrType) || "LocalDateTime".equals(attrType) || "LocalDate".equals(attrType))) {
                hasDate = true;
            }

            //是否主键
            if ("PRI".equalsIgnoreCase(column.get("columnKey" )) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
            }
            columnEntity.setDataType(columnEntity.getDataType().toLowerCase());
            columnsList.add(columnEntity);
        }
        tableEntity.setColumns(columnsList);

        //没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader" );
        Velocity.init(prop);
        String mainPath = config.getString("mainPath" );
        mainPath = StringUtils.isBlank(mainPath) ? "com.inmr" : mainPath;
        //封装模板数据
        Map<String, Object> map = new HashMap<>(16);

        //
        map.put("serialVersionUID",BigDecimal.valueOf(9223372036854775807L).multiply(BigDecimal.valueOf(Math.random())).longValue()+"L");

        map.put("tableName", tableEntity.getTableName().toLowerCase(Locale.ROOT));
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("getPk", FieldUtils.genGetMethodName(tableEntity.getPk().getAttrname()));
        map.put("setPk", FieldUtils.genGetMethodName(tableEntity.getPk().getAttrname()));
        map.put("className", tableEntity.getClassName());
        map.put("classname", tableEntity.getClassname());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("hasGmtFields", tableEntity.getHasGmtFields());
        map.put("hasBigDecimal", hasBigDecimal);
        map.put("hasDate", hasDate);
        map.put("mainPath", mainPath);
        map.put("appName", config.getString("appName" ));
        map.put("basePackage", config.getString("basePackage" ));
        map.put("package", config.getString("package" ));
        map.put("commonUrlPrefix",config.getString("commonUrlPrefix" ));
        map.put("moduleName", config.getString("moduleName" ));
        map.put("moduleLeaf", config.getString("moduleLeaf" ));
        map.put("modulePath", map.get("moduleName")+"/"+map.get("moduleLeaf"));

        map.put("author", config.getString("author" ));
        map.put("email", config.getString("email" ));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        VelocityContext context = new VelocityContext(map);

        //获取模板列表
        List<String> templates = getTemplatesPlus();
        for (String template : templates) {


            try {
                //渲染模板
                StringWriter sw = new StringWriter();
                Template tpl = Velocity.getTemplate(template, "UTF-8" );
                tpl.merge(context, sw);

                //添加到zip
                zip.putNextEntry(new ZipEntry(getFileName(template, tableEntity.getClassName(), map)));
                IOUtils.write(sw.toString(), zip, "UTF-8" );
                IOUtils.closeQuietly(sw);
                zip.closeEntry();
            } catch (IOException e) {
                throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }
    }


    /**
     * 列名转换成Java属性名
     */
    public static String columnToJava(String columnName) {
        return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_", "" );
    }

    /**
     * 表名转换成Java类名
     */
    public static String tableToJava(String tableName, String[] tablePrefixArray) {
        if(null != tablePrefixArray && tablePrefixArray.length>0){
            for(String tablePrefix : tablePrefixArray){
                tableName = tableName.replace(tablePrefix, "");
            }
        }
        return columnToJava(tableName);
    }

    /**
     * 获取配置信息
     */
    public static Configuration getConfig() {
        try {
            return new PropertiesConfiguration("generator.properties" );
        } catch (ConfigurationException e) {
            throw new RRException("获取配置文件失败，", e);
        }
    }

    /**
     * 获取文件名
     */
    public static String getFileName(String template, String className, Map<String,Object> map) {

        String packagePath = "main" + File.separator + "java" + File.separator;

        String appName = map.getOrDefault("appName","default").toString();
        String packageName = map.getOrDefault("package","com.inmr").toString();
        String moduleName = map.getOrDefault("moduleName","default").toString();
        //String modulePath = map.getOrDefault("modulePath","default").toString();
        String moduleLeaf= map.getOrDefault("moduleLeaf","default").toString();
        if (StringUtils.isNotBlank(packageName)) {
            packagePath += packageName.replace(".", File.separator) + File.separator + moduleName + File.separator;
        }

        if (template.contains("Entity.java.vm" )) {
            return packagePath + "entity" + File.separator + className + "Entity.java";
        }
        if (template.contains("Model.java.vm" )) {
            return packagePath + "model" + File.separator + className + "Model.java";
        }

        if (template.contains("Dao.java.vm" )) {
            return packagePath + "dao" + File.separator + className + "Dao.java";
        }

        if (template.contains("Repository.java.vm" )) {
            return packagePath + "repository" + File.separator + className + "Repository.java";
        }

        if (template.contains("Service.java.vm" )) {
            return packagePath + "service" + File.separator + className + "Service.java";
        }

        if (template.contains("ServiceImpl.java.vm" )) {
            return packagePath + "service" + File.separator + "impl" + File.separator + className + "ServiceImpl.java";
        }
        if (template.contains("BizCheck.java.vm" )) {
            return packagePath + "bizcheck" + File.separator + className + "BizCheck.java";
        }

        if (template.contains("Controller.java.vm" )) {
            return packagePath + "controller" + File.separator + className + "Controller.java";
        }

        if (template.contains("VO.java.vm" )) {
            return packagePath + "controller"+ File.separator +" vo" + File.separator + className + "VO.java";
        }

        if (template.contains("CreateCmd.java.vm" )) {
            return packagePath + "controller"+ File.separator +" cmd" + File.separator + className + "CreateCmd.java";
        }
        if (template.contains("UpdateCmd.java.vm" )) {
            return packagePath + "controller"+ File.separator +" cmd" + File.separator + className + "UpdateCmd.java";
        }

        if (template.contains("Query.java.vm" )) {
            return packagePath + "controller"+ File.separator +" query" + File.separator + className + "Query.java";
        }

        if (template.contains("Assembler.java.vm")){
            return packagePath + "assembler" + File.separator + className + "Assembler.java";

        }
        if (template.contains("Mapper.java.vm" )) {
            return packagePath + "mapper" + File.separator + className + "Mapper.java";
        }

        if (template.contains("Mapper.xml.vm" )) {
            return packagePath + "mapper" + File.separator + className + "Mapper.xml";
        }

        if (template.contains("menu.sql.vm" )) {
            return className.toLowerCase() + "_menu.sql";
        }
        if (template.contains("test.http.vm" )) {
            return "test" + File.separator + "http" + File.separator + moduleName + "-" + moduleLeaf +  ".http";
        }


        if (template.contains("index.html.vm" )) {
            return "main" + File.separator + "resources" + File.separator + "templates" + File.separator + appName + File.separator + moduleName +
                    File.separator + moduleLeaf +  "_index.html";
        }
        if (template.contains("index-thymeleaf.html.vm" )) {
            return "main" + File.separator + "resources" + File.separator + "templates" + File.separator + appName + File.separator + moduleName +
                    File.separator + moduleLeaf +  "_t_index.html";
        }

        if (template.contains("edit.html.vm" )) {
            return "main" + File.separator + "resources" + File.separator +  "templates" + File.separator + appName + File.separator + moduleName +
                    File.separator + moduleLeaf +  "_edit.html";
        }

        if (template.contains("index.vue.vm" )) {
            return "main" + File.separator + "resources" + File.separator + "src" + File.separator + "views" + File.separator + "modules" +
                    File.separator + moduleLeaf + File.separator + className.toLowerCase() + ".vue";
        }

        if (template.contains("add-or-update.vue.vm" )) {
            return "main" + File.separator + "resources" + File.separator + "src" + File.separator + "views" + File.separator + "modules" +
                    File.separator + moduleLeaf + File.separator + className.toLowerCase() + "-add-or-update.vue";
        }

        return null;
    }
}
